Channel: ExcelVbaIsFun

Category: Education

Tags: excel vba is funis microsoft disabling vbadisable vba code in excelexcelvbaisfundan strongis vba going awayis vba deaddisable vba excelexcel vbais vbadaniel strong vbadisable vba

Description: Is Microsoft disabling VBA and macros in all of their office products?! That's a question I got this week and we're going to deep dive and explore that thoroughly in this episode of Excel VBA Is Fun! Since the 1990s, macros have been a part of the Microsoft Office suite and since the 90s, unscrupulous jerk dirtbags have been using them to put malware and bad code in there that could take over or just do bad things to your computer. They might try to wipe out a folder here and there or just take over control, spy on your files, etc. Microsoft is finally cracking down on that, so let's explore this question a little bit further! In this video, we explore the new security updates coming to Microsoft Office products starting April 2022 that are changing the way Macro-Enabled documents are going to work. We'll explore which apps are affected and their timeline for the rollout of the new features as well as the look and feel of the new warning screens. Furthermore, we're also going to do a deep dive into which files will specifically be hit and which ones are safe to use without further action. We have a flowchart that will show you the path Office documents will go through to deem a file safe or needing further security first. Once you've seen the video, it will make more sense. You don't need to worry! I'll show you several ways to easily avoid this warning and I'll even show you how to resolve a file - even if you see the new warning. I'll also show you a neat trick that allows you to open a macro-enabled file to inspect the code safely in a way that disabled the macros but still allows you to look through them and vet them. Then, I'll give you a quick walkthrough of how to vet code from a workbook you got from the internet or someone else. Learn more about Code Signing Certificates: excelvbaisfun.com/product/software-code-signing-for-enhanced-security-and-brand-trust 00:00 Intro - New Security Features 00:42 The Short Answer... 01:28 Which apps are affected? 01:44 Rollout timetable 02:32 What does it look like? 03:31 Will it happen to ALL Excel, Word etc Files? 03:43 What is MOTW? 04:16 'Explain it to me like I'm five' Flowchart 04:48 How to add a Trusted Location 05:37 Code signing a document 05:55 Your company's policies 06:50 Making a Trusted Document 07:19 How to Solve? 08:31 Final Tips - Part 1 10:03 How to Open File (to inspect) with Macros Disabled 11:39 How to safely vet other people's code 12:40 Final Tips 13:32 More Videos (and Subscribe) Get My Bestselling Excel VBA Courses: Excel VBA Essentials Course: bit.ly/UltExcelVBA Control Websites With Excel VBA: bit.ly/VbaWebAutomation Speed Up Code With VBA Arrays: bit.ly/VbaArrays Create Your Own Functions/Addins: bit.ly/CustomUDFsAddins Fill PDFs/Forms with Excel VBA: bit.ly/VbaPDFsMastery Excel VBA Barcode Lookup System & Inventory Projects: bit.ly/VbaBarcodesProjects Instantly Secure Excel Files; Transform Into EXE Programs!: bit.ly/Excel2EXE Automate Outlook with Excel VBA: bit.ly/ExcelVBAOutlook Professional Animations In Excel by Kishon: click.linksynergy.com/deeplink?id=BYzUIhHF1Ys&mid=39197&murl=https%3A%2F%2Fwww.udemy.com%2Fmicrosoft-excel-animation-for-great-user-experience%2F Fantastic Developer Tools: Lock Any Workbook Into An EXE (Software only, see course above): excelvbaisfun.com/get-xlspadlock Create Custom Installers: excelvbaisfun.com/get-pb Free Ebook: excelvbaisfun.com/FreeEbook Dan Strong's Articles: excelvbaisfun.com/blog Free Excel Workbooks: excelvbaisfun.com/free-workbooks Business Inquiries, Consulting, Comments, etc: excelvbaisfun.com/contact ExcelVbaIsFun YouTube Playlists: Excel Vba Basics: bit.ly/ExcelVbaBasicsPlaylist Tips N Tricks: bit.ly/VbaTipsNTricksPlaylist Userforms: bit.ly/ExcelVbaUserformsPlaylist Events Series: bit.ly/VbaEventsPlaylist Activex Controls: bit.ly/VbaActiveXPlaylist Sample Excel Programs: bit.ly/SampleExcelPrograms Where else you can find me: LinkedIn: linkedin.com/in/danielcstrong Facebook: facebook.com/Excelvbaisfun Twitter: twitter.com/ExcelVbaIsFun Google Plus+: google.com/+ExcelVbaIsFun T-Shirts/Merch: ExcelVbaIsFun.spreadshirt.com 'Royalty Free Music by audiomicro.com/royalty-free-music'